select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Exclusive Embroidery Strapless Dress for Quince with Pick-ups
Fuchsia Strapless Appliques and Pick-ups Quinceanera Dresses
Modest Embroidery Strapless Hand Made Flower Quince Dresses
Beading Ruches and Ruffles Sweetheart Ball Gown Sweet 15 Dresses
Pick-ups and Pleats Accent Dress for Quince with Chic Capelet
Strapless Ball Gown Appliques and Ruffles Quinceanera Dresses
Colorful Ball Gown Strapless Organza Beading Sweet 15 Dresses
Spring Green Ball Gown off the Shoulder Quinceanera Dresses
Yellow Green Ball Gown Sweetheart Appliques Quince Dresses
Azure Strapless Appliques and Pick-ups Ball Gown Sweet 15 Dresses
Strapless Ruches and Lace Decorate Ball Gown Sweet 15 Dresses
Chic Two-toned Sweetheart Ball Gown Lace up front Quince Dresses
Red Ball Gown Taffeta Quinceanera Dresses with Pick Ups
Lavender Strapless Ball Gown Organza Appliques Quince Dresses
Coral Red Organza Strapless Ball Gown Sweet Sixteen Dresses
Fuchsia Ball Gown Embroidery Sweet Sixteen Dresses Floor-length
White Ball Gown Embroidery Dresses for a Quinceanera in Fashion
Latest Aqua Blue Strapless Appliques Dress for a Quince in Taffeta
Impressive Aqua Blue Beading Quinceanera Dresses with Ruffles
White and Pink Strapless Dress for Quinceanera with Embroidery
Best Strapless Beading Aqua Blue Dress for Quince with Pick-ups
Princess White Strapless Organza Sweet 15 Dress with Embroidery
Multi-layer Hot Pink Sweetheart Quinceanera Dress with Appliques
White Strapless Appliques Sweet Sixteen Dresses with Floor-length
Unique White Ball Gown Strapless Sweet 16 Dresses with Appliques
Ball Gown Beaded and Ruched Dresses for a Quinceanera in Style
Purple Sweetheart Embroidery Sweet Fifteen Dresses on Discount
Brush Train Spaghetti Straps Sweet Sixteen Dresses with Appliques
Wine Red Sweetheart Embroidery Dresses Quinceanera Court Train
American Music Awards Recommended Ball Gown Beading Sweet 15 Dresses with Pick-ups